package com.coupons.business.page.dao;

import java.util.List;

import com.coupons.business.common.exception.BaseCouponsAppException;
import com.coupons.business.common.vo.Page;

public interface IPageDAO 
{
	public void createPage(Page objaPage) throws BaseCouponsAppException;
	public void updatePage (Page objaPage) throws BaseCouponsAppException;
	public Page getPage(int PageId) throws BaseCouponsAppException;
	public List<Page> getAllPages()throws BaseCouponsAppException ;
	
	public String PAGE_INSERT_STATEMENT = "INSERT INTO PAGE(PAGE_ID,PAGE_NAME,DESCRIPTION) VALUES(?,?,?)";
	
	public String PAGE_UPDATE_STATEMENT = "UPDATE PAGE SET PAGE_NAME = ?, DESCRIPTION = ? WHERE PAGE_ID = ?"; 
	
	public String SEQUENCE_NAME="PAGE_SQ";
	
	public String GET_ALL_PAGES_STATEMENT = "SELECT * FROM PAGE";
	
	public String GET_PAGE_STATEMENT = "SELECT * FROM PAGE where PAGE_ID = ?";
}

